#SQL:查询每日所有商品累计收入
sql_daily_income="select * from market.dailyIncome"

#SQL:查询每月所有商品累计收入
sql_monthly_income="select * from market.monthlyIncome where dt ='{}'"

#SQL:按起始和截至日期查询所有商品累计收入
sql_daily_income_interval="select * from market.dailyIncome where dt between '{}' and '{}'"

#SQL:查询所有商品累计收入
sql_goods_total_income="select * from market.GoodsTotalIncome"

#SQL:查询所有商品累计收入并按收入高低排序
sql_goods_total_income_order="select * from market.GoodsTotalIncome order by income"

#SQL:查询每日各商品销售收入
sql_daily_goods_income="select * from market.dailyGoodsIncome where dt='{}'"

#SQL:查询每日分时段商品累计销售收入
sql_daily_hourly_income="select * from market.dailyHourlyGoodsIncome where dt='{}'" 

#SQL:查询每日各会员消费金额
sql_vip_daily_expense="select * from market.vipDailyExpense where dt='{}' order by expense desc limit 50"

#SQL:查询某会员每日消费金额
sql_daily_expense_vip="select * from market.vipDailyExpense where userID='{}' and dt between '{}' and '{}'"

#SQL:查询历史会员消费总金额
sql_vip_total_expense="select * from market.vipTotalExpense order by expense desc limit 50"

#SQL:查询会员近半年消费商品频率
sql_vip_favorate_items="select gname,buytimes from market.vipGoodsFavorite where userID='{}'" 